<%-- 
    Document   : combo_02
    Created on : 8-mag-2011, 19.23.39
    Author     : ste
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
   "http://www.w3.org/TR/html4/loose.dtd">

<%@ page import="java.sql.ResultSet" %>

<jsp:useBean id="connManager" class="operazioni_database.DoQuery" scope="request" />

<html>
    <head>
        <style>
            A:hover {text-decoration: none;

                border: 0px;
                font-size:14pt;
                color: #2d2b2b; }
        </style>

        <link rel="stylesheet" type="text/css" href="datepicker.css"/>
    </head>

    <script language="Javascript" type="text/javascript" src="ajaxEmp.js"></script>
    
    <body>
        <form name="employee">
            <br><br>
            <table border="0" width="400px" align="center" bgcolor="#CDFFFF">
                <div id="mydiv"></div>
                <tr><td><b>Select Employee Id</b></td><td>
                        <select name="semp_id" onchange="showEmp(this.value);">
                            <option value="-1">Select</option>
                            <%

                                ResultSet rs = (ResultSet)request.getAttribute("ResultSet");
                            %>

                            <%
                                    while (rs.next()) {
                            %>


                            <option value="<%=rs.getString(1)%>"><%=rs.getString(1)%></option>

                            <%
                                    }
                            %>

                        </select>
                </td></tr>
                <tr><td ><b>Employee Id:</b></td><td>
                <input  type="text" name="emp_id" id="emp_id" value=""></td></tr>
                <tr><td><b>Employee Name:</b></td><td>
                <input  type="text" name="emp_name" id="ename" value=""></td></tr>
                <tr><td><b>Employee Surname:</b></td><td>
                <input  type="text" name="emp_surname" id="esurname" value=""></td></tr>

            </table>
        </form>
        <table border="0" width="100%" align="center">
            <br>
            <br>
        </table>
    </body>
</html>

